<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Using the Export Options dialog box</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
p.whs1 { font-weight:normal; }
ol.whs2 { list-style:decimal; }
ul.whs3 { list-style:square; }
img_whs4 { border:none; width:19px; height:18px; float:none; border-style:none; }
img_whs5 { border:none; width:16px; height:16px; float:none; border-style:none; }
p.whs6 { margin-left:40px; }
ul.whs7 { list-style:disc; }
p.whs8 { font-weight:bold; }
h2.whs9 { margin-left:40px; }
ol.whs10 { list-style:disc; }
p.whs11 { margin-top:0pt; margin-bottom:0pt; }
p.whs12 { margin-top:0pt; margin-bottom:0pt; margin-left:80px; }
p.whs13 { margin-top:0pt; margin-bottom:0pt; margin-left:0px; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs11 {margin-top:1pt;margin-bottom:1pt; }";
  strNSS += "p.whs12 {margin-top:1pt;margin-bottom:1pt; }";
  strNSS += "p.whs13 {margin-top:1pt;margin-bottom:1pt;margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Saving, exporting, emailing, or printing a report or document\nInterfaces for saving, exporting, and printing a report\nUsing the Export Options dialog box");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Using the Export Options dialog box</h1>
<p class="whs1">The Export Options dialog box lets you 
 set defaults for exporting reports in CSV file format, Excel, plain text, 
 or HTML. For example, if most of your reports exported in plain text contain 
 the same headers and footers, then you can designate default headers and 
 footers to display each time that you export to plain text. </p>
<ol type="1" class="whs2">
	
<li class=p><p>You can export a report directly from a folder, or you 
 can export it while viewing it:</p></li>
	<ul type="square" class="whs3">
		
<li class=p><p><span style="font-weight: bold;"><B>To export a report 
 directly from a folder</B></span>: Right-click the report and highlight <span 
 style="font-weight: bold;"><B>Run as</B></span>.</p></li>
		<ul type="square" class="whs3">
			
<li class=p><p>If DHTML is disabled, click the <span style="font-weight: bold;"><B>Export</B></span> 
 icon <img src="images/export2.gif" x-maintain-ratio="TRUE" width="19px" height="18px" border="0" class="img_whs4"> or <span style="font-weight: bold;"><B>PDF</B></span> icon <img src="images/pdf2.gif" x-maintain-ratio="TRUE" width="16px" height="16px" border="0" class="img_whs5"> 
 in the <span style="font-weight: bold;"><B>Actions</B></span> column.</p></li>
		</ul>
		
<li class=p><p><span style="font-weight: bold;"><B>To export a report 
 while viewing it</B></span>: Click the name of a report to display it. From 
 the <span style="font-weight: bold;"><B>Home</B></span> menu, select <span style="font-weight: bold;"><B>Export</B></span>.</p></li>
	</ul>
</ol>
<ol start="2" type="1" class="whs2">
	
<li class=p><p>From the <span style="font-weight: bold;"><B>Home</B></span> 
 menu, select <span style="font-weight: bold;"><B>Export</B></span>, and then 
 select one of the following export formats:</p></li>
</ol>
<ul type="square" class="whs3">
	<ul type="square" class="whs3">
		
<li class=p><p><span style="font-weight: bold;"><B>PDF</B></span>: Export 
 the report to an Adobe PDF file.</p></li>
		
<li class=p><p><span style="font-weight: bold;"><B>Excel with plain 
 text</B></span>: Export the report to Microsoft Excel as plain text. The content 
 of the report is displayed using the default settings in Microsoft Excel. 
 The structure and format of the report, as it is displayed in MicroStrategy 
 Web, is not retained. For large report results, this export option is 
 recommended over <span style="font-weight: bold;"><B>Excel with formatting</B></span>.</p></li>
		
<li class=p><p><span style="font-weight: bold;"><B>CSV file format</B></span>: 
 Export the report into a comma-separated values (CSV) format as plain 
 text. This format is suitable for Microsoft Access and Lotus 1-2-3. The 
 structure and format of the report, as it is displayed in MicroStrategy 
 Web, is not retained.</p></li>
		
<li class=p><p><span style="font-weight: bold;"><B>Excel with formatting</B></span>: 
 Export the report to Microsoft Excel with the same formatting and structure 
 that appears in MicroStrategy Web. Microsoft Excel does not support all 
 colors that browsers do, so some colors may differ after export.</p></li>
		
<li class=p><p><span style="font-weight: bold;"><B>HTML</B></span>: Export 
 the report to an HTML page. The structure and format of the report, as 
 it is displayed in MicroStrategy Web, is retained.</p></li>
		
<li class=p><p><span style="font-weight: bold;"><B>Plain text</B></span>: 
 Export the content of the report to a plain text page. The structure and 
 format of the report, as it is displayed in MicroStrategy Web, is not 
 retained. You can choose a comma, tab, semicolon, or space to separate 
 the fields of text.</p></li>
	</ul>
</ul>
<p class="whs6"><span style="font-weight: bold;"><B>Note</B></span>: 
 In a document, if there are objects in the Grouping panel and you choose 
 to export the document to PDF or Excel format, a message is displayed. 
 Select the <span style="font-weight: bold;"><B>Expand Page-by</B></span> check 
 box to confirm that you want to expand the page-by fields to be displayed 
 after exporting. </p>
<ol start="3" type="1" class="whs2">
	
<li class=p><p>If you are exporting directly from a folder, if the 
 report contains prompts answer them and click <span style="font-weight: bold;"><B>Export</B></span> 
 </p></li>
	
<li class=p><p>From the <span style="font-weight: bold;"><B>Export</B></span> 
 drop-down list, select either <span style="font-weight: bold;"><B>Whole report</B></span> 
 or <span style="font-weight: bold;"><B>Portion displayed only</B></span> to choose 
 to export either the entire report or only the portion of your report 
 displayed in your browser.</p></li>
	
<li class=p><p><span style="margin-left: 40px;">Depending on which 
 export format you choose, you may have access to the following options:</span></p></li>
</ol>
<ul type="disc" class="whs7">
	<ul type="disc" class="whs7">
		
<li class=p><p><span style="font-weight: bold;"><B>Delimiter</B></span>: 
 Select one of the options from the drop-down list. The delimiter that 
 you choose separates each cell of data in the exported report. The options 
 are <span style="font-weight: bold;"><B>Comma</B></span>, <span style="font-weight: bold;"><B>Tab</B></span>, 
 <span style="font-weight: bold;"><B>Semicolon</B></span>, <span style="font-weight: bold;"><B>Space</B></span>, 
 and <span style="font-weight: bold;"><B>Tilde</B></span>. </p></li>
		
<li class=p><p class="whs8">Export Report Title<span 
 style="font-weight: normal;">: Determine whether to display the report 
 title in the exported report.</span></p></li>
		
<li class=p><p class="whs8">Export filter details<span 
 style="font-weight: normal;">: Determine whether to display the report’s 
 filter details in the exported report.</span> </p></li>
		
<li class=p><p class="whs8">Remove extra column<span 
 style="font-weight: normal;">: Determine whether the word Metric will 
 be displayed in the exported report. Select either </span>Automatic<span 
 style="font-weight: normal;">, </span>Yes<span style="font-weight: normal;">, 
 or </span>No<span style="font-weight: normal;"> from the drop-down list. 
 Automatic allows this export option to be determined by the report’s designer.</span></p></li>
		
<li class=p><p class="whs8"><span><B>Do not prompt me 
 again</B></span><span style="font-weight: normal;">: Determine whether you 
 would like to be prompted with the Export Option dialog box the next time 
 that you want to export. If you choose not to be prompted, future exports 
 will use these same settings.</span></p></li>
		
<li class=p><p class="whs8">Export Header and Footer<span 
 style="font-weight: normal;">: Determine how you want your headers and 
 footers to display in the exported report. In the </span>Edit Custom Settings<span 
 style="font-weight: normal;"> option, you can select which text to insert 
 into the exported Header and Footer fields. You can type your own text 
 in the fields or you can select an auto text entry from the drop-down 
 list. For more information about auto-text, see 
<a href="Auto_text_codes_datasets.htm">Auto 
 text codes for datasets</a>.</span></p></li>
	</ul>
</ul>
<h2 class="whs9">Excel options</h2>
<ol type="disc" class="whs10">
	<ul type="disc" class="whs7">
		
<li class=p><p class="whs8">Export metric values 
 as text<span style="font-weight: normal;">: Determine whether you want 
 to display metric values as text in the exported report. This setting 
 can only be enabled if exporting to Excel formatting or Excel with plain 
 text.</span> </p></li>
		
<li class=p><p><span style="font-weight: bold;"><B>Export headers 
 as text</B></span>: Determine whether you want to display headers as text 
 in the exported report. This setting can only be enabled if exporting 
 to Excel formatting or Excel with plain text. </p></li>
	</ul>
</ol>
<h2 class="whs9">Excel with formatting options</h2>
<ol type="disc" class="whs10">
	<ul type="disc" class="whs7">
		
<li class=p><p><span style="font-weight: bold;"><B>Embed Images</B></span>: 
 Determine whether you can see images when you open the Excel file on another 
 computer that does not have a network connection. </p></li>
		
<li class=p><p class="whs11"><span 
 style="font-weight: bold;"><B>Allow MicroStrategy Office to refresh Report 
 after exporting</B></span>: Determine whether MicroStrategy Office will refresh 
 the report results after you export the report. </p></li>
	</ul>
</ol>
<p class="whs12"><span 
 style="font-weight: bold;"><B>Note</B></span>:<span style="font-weight: bold;"> 
 <B></B></span>You must own the MicroStrategy Office product to use this setting.<span 
 style="margin-left: 40px; margin-top: 0pt; margin-bottom: 0pt;"> </span></p>
<p class="whs13">&nbsp;</p>
<ol start="5" type="1" class="whs2">
	
<li class=p><p class="whs11">Click <span 
 style="font-weight: bold;"><B>Export</B></span><span>. </span></p></li>
</ol>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
